package com.itheima.ssm.dao;

import com.itheima.ssm.domain.Traveller;
import org.apache.ibatis.annotations.Select;

import java.util.List;

//根据订单的ID在中间表中去查询旅客的信息
public interface ITravellerDao {
    @Select("select * from traveller where id in (select travellerId from order_traveller where orderid = #{orderId} )")
    List<Traveller> findByOrdersId(String orderId) throws Exception;
}
